-- 库存服务

-- 创建库
create database if not exists mall_wms;

-- 切换库
use mall_wms;


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for undo_log
-- 创建一个名为undo_log的表，用于存储事务回滚相关的信息
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `branch_id` bigint NOT NULL COMMENT '标识分布式事务中的特定分支',
  `xid` varchar(100) NOT NULL COMMENT '全局唯一标识一个分布式事务',
  `context` varchar(128) NOT NULL COMMENT '事务相关的上下文数据',
  `rollback_info` longblob NOT NULL COMMENT '序列化的信息以便事务回滚',
  `log_status` int NOT NULL  COMMENT '日志记录状态(设置)',
  `log_created` datetime NOT NULL COMMENT '日志创建时间点',
  `log_modified` datetime NOT NULL COMMENT '日志修改时间点',
  `ext` varchar(100) DEFAULT NULL COMMENT '扩展字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='事务回滚相关的信息';

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wms_purchase
-- ----------------------------
DROP TABLE IF EXISTS `wms_purchase`;
CREATE TABLE `wms_purchase` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '需求名称',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '采购状态 0 未采购 1 采购中 2 已完成 3 有异常 4 失败',
  `linkman` varchar(255) NOT NULL COMMENT '采购联系人',
  `phone` varchar(20) NOT NULL COMMENT '采购人联系方式',
  `create_time` datetime  DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '创建时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP NOT NULL  ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `is_deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '逻辑删除',
  `version` int NOT NULL DEFAULT '0' COMMENT '版本',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1672126893741182978 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='采购信息';

-- ----------------------------
-- Records of wms_purchase
-- ----------------------------
BEGIN;
INSERT INTO `wms_purchase` (`id`, `name`, `status`, `linkman`, `phone`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`, `version`) VALUES (1670427263454384121, '数码产品采购', 2, '利若', '1223', '2023-06-18 21:44:29', 'Leron', '2023-06-18 23:46:50', 'Leron', b'0', 0);
INSERT INTO `wms_purchase` (`id`, `name`, `status`, `linkman`, `phone`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`, `version`) VALUES (1672126893741182977, '数码商品采购', 0, '利若', '1223', '2023-06-23 14:18:13', 'Leron', '2023-06-18 23:46:50', 'Leron', b'0', 0);
COMMIT;

-- ----------------------------
-- Table structure for wms_purchase_detail
-- 创建`wms_purchase_detail`表，用于存储采购详情信息
-- ----------------------------
DROP TABLE IF EXISTS `wms_purchase_detail`;
CREATE TABLE `wms_purchase_detail` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `purchase_id` bigint NOT NULL COMMENT '采购单id',
  `sku_id` bigint NOT NULL COMMENT '采购商品id',
  `sku_num` int NOT NULL COMMENT '采购数量',
  `ware_id` bigint NOT NULL COMMENT '仓库id',
  `finish_time` datetime DEFAULT NULL COMMENT '完成时间',
  `status` tinyint NOT NULL COMMENT '状态 [0: 未开始, 1: 采购中, 2: 已完成, 3: 采购失败]',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP not null comment '创建时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP not null ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记 (0: 未删除, 1: 已删除)',
  `version` int NOT NULL DEFAULT '0' COMMENT '版本号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1675422836502704130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='采购详情信息';

-- ----------------------------
-- Records of wms_purchase_detail
-- ----------------------------
BEGIN;
INSERT INTO `wms_purchase_detail` (`id`, `purchase_id`, `sku_id`, `sku_num`, `ware_id`, `finish_time`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`, `version`) VALUES (1670449900620554241, 1670427263454384129, 1647522986192986114, 20, 1, '2023-06-18 23:45:54', 2, '2023-06-18 23:14:26', 'Leron', '2023-06-18 23:45:54', 'Leron', 0, 0);
INSERT INTO `wms_purchase_detail` (`id`, `purchase_id`, `sku_id`, `sku_num`, `ware_id`, `finish_time`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`, `version`) VALUES (1672127731427577857, 1672126893741182977, 1647519694947803138, 999, 1, '2023-06-23 14:24:18', 2, '2023-06-23 14:21:32', 'Leron', '2023-06-23 14:24:18', 'Leron', 0, 0);
INSERT INTO `wms_purchase_detail` (`id`, `purchase_id`, `sku_id`, `sku_num`, `ware_id`, `finish_time`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`, `version`) VALUES (1672128320756649986, 1672126893741182977, 1647519696118013954, 999, 1, '2023-06-23 14:24:19', 2, '2023-06-23 14:23:53', 'Leron', '2023-06-23 14:24:19', 'Leron', 0, 0);
INSERT INTO `wms_purchase_detail` (`id`, `purchase_id`, `sku_id`, `sku_num`, `ware_id`, `finish_time`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`, `version`) VALUES (1675422586597683201, 1672126893741182977, 1647519692183756801, 100, 1, NULL, 0, '2023-07-02 16:34:07', 'Leron', '2023-07-02 16:34:26', 'Leron', 1, 0);
INSERT INTO `wms_purchase_detail` (`id`, `purchase_id`, `sku_id`, `sku_num`, `ware_id`, `finish_time`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`, `version`) VALUES (1675422836502704129, 1672126893741182977, 1647519692183756801, 100, 1, '2023-07-02 16:35:11', 2, '2023-07-02 16:35:07', 'Leron', '2023-07-02 16:35:11', 'Leron', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for wms_ware
-- 仓库信息(可更改)
-- ----------------------------
DROP TABLE IF EXISTS `wms_ware`;
CREATE TABLE `wms_ware` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '仓库名',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '仓库地址',
  `area_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '区域编码',
  `sort` int NOT NULL DEFAULT '999' comment '类型',
  `status` tinyint NOT NULL DEFAULT '0' comment '状态',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP not null comment '创建时间',
  `create_by` varchar(255) DEFAULT NULL comment '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP not null ON UPDATE CURRENT_TIMESTAMP comment '更新时间',
  `update_by` varchar(255) DEFAULT NULL comment '更新人',
  `version` int NOT NULL DEFAULT '0' comment '版本',
  `is_deleted` bit(1) NOT NULL DEFAULT b'0' comment '逻辑删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1670346103004991490 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='仓库信息';


-- ----------------------------
-- Records of wms_ware
    -- (第一行问题)
-- ----------------------------
BEGIN;
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1, '1号仓库', '山东济南', '10000', 0, 1, '2023-06-18 16:13:30', NULL, '2023-06-18 16:26:03', 'Leron', 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670343969421361153, '苏州虎丘仓库', '江苏省苏州市吴中区', '000000', 1, 1, '2023-06-18 16:13:30', 'Leron', '2023-06-18 16:13:30', NULL, 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670344924275634177, '青岛李沧仓库', '青岛市李沧区', '0192', 1, 1, '2023-06-18 16:17:18', 'Leron', '2023-06-18 16:13:30', NULL, 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670345383958679554, '青岛黄岛区仓库', '青岛石油大学附近', '0192', 1, 1, '2023-06-18 16:19:08', 'Leron', '2023-06-18 16:13:30', NULL, 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670345458873143297, '烟台仓库', '烟台大学附近', '003123', 1, 1, '2023-06-18 16:19:26', 'Leron', '2023-06-18 16:28:43', 'Leron', 0, b'1');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670345548710940674, '菏泽仓库', '山东省菏泽市成武县', '02112', 1, 1, '2023-06-18 16:19:47', 'Leron', '2023-06-18 16:13:30', NULL, 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670345660212318210, '浙江杭州仓库', '浙江省杭州市', '0123', 1, 1, '2023-06-18 16:20:14', 'Leron', '2023-06-18 16:13:30', NULL, 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670345782165901314, '苏州吴中仓库', '苏州市吴中区', '12234', 1, 1, '2023-06-18 16:20:43', 'Leron', '2023-06-18 16:13:30', NULL, 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670345880727851010, '常州武进仓库', '常州市武进区', '33921', 1, 1, '2023-06-18 16:21:06', 'Leron', '2023-06-18 16:13:30', NULL, 0, b'0');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670345987372224514, '上海仓库', '上海市浦东区', '22123', 1, 1, '2023-06-18 16:21:32', 'Leron', '2023-06-18 16:28:27', 'Leron', 0, b'1');
INSERT INTO `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1670346103004991489, '青岛市北仓库', '青岛市市北区', '102973', 1, 0, '2023-06-18 16:21:59', 'Leron', '2023-06-18 17:54:39', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (2, '甘肃', '兴平', '皖E00001', 1, 0, '2022-01-04 02:19:40', 'Leron', '2022-05-10 23:01:10', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (3, '澳门', '兴宁市', '皖E00010', 1, 0, '2022-03-27 00:46:10', 'Leron', '2022-01-11 13:07:44', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (4, '内蒙古', '河间市', '皖E00005', 1, 0, '2022-03-03 22:35:17', 'Leron', '2022-02-13 21:24:07', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (5, '江西', '五大连池市', '皖E00012', 1, 0, '2022-09-20 18:11:58', 'Leron', '2022-03-28 04:45:23', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (6, '宁夏', '耒阳市', '皖E00007', 1, 0, '2022-04-20 05:41:40', 'Leron', '2022-01-04 03:44:45', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (7, '甘肃', '开原市', '皖E00014', 1, 0, '2022-09-15 18:05:41', 'Leron', '2022-11-28 16:51:31', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (8, '香港', '鞍山市', '皖E00006', 1, 0, '2022-08-01 10:24:48', 'Leron', '2022-05-24 18:53:25', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (9, '广东', '平顶山市', '皖E00005', 1, 0, '2022-02-07 03:24:17', 'Leron', '2022-03-19 02:39:24', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (10, '福建', '潮州市', '皖E00005', 1, 0, '2022-03-19 00:41:19', 'Leron', '2022-09-17 21:41:04', 'Leron', 0, b'0');
insert into `wms_ware` (`id`, `name`, `address`, `area_code`, `sort`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) values (11, '西藏', '武汉市', '皖E00004', 1, 0, '2022-07-01 23:54:55', 'Leron', '2022-06-23 22:41:40', 'Leron', 0, b'0');
COMMIT;

-- ----------------------------
-- Table structure for wms_ware_order_task
-- 库存工作单
-- ----------------------------
DROP TABLE IF EXISTS `wms_ware_order_task`;
CREATE TABLE `wms_ware_order_task` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_id` bigint DEFAULT NULL COMMENT 'order_id',
  `order_sn` varchar(255) DEFAULT NULL COMMENT 'order_sn',
  `consignee` varchar(100) DEFAULT NULL COMMENT '收货人',
  `consignee_tel` char(15) DEFAULT NULL COMMENT '收货人电话',
  `delivery_address` varchar(500) DEFAULT NULL COMMENT '配送地址',
  `order_comment` varchar(200) DEFAULT NULL COMMENT '订单备注',
  `payment_way` tinyint(1) DEFAULT NULL COMMENT '付款方式【 1:在线付款 2:货到付款】',
  `task_status` tinyint DEFAULT NULL COMMENT '任务状态',
  `order_body` varchar(255) DEFAULT NULL COMMENT '订单描述',
  `tracking_no` char(30) DEFAULT NULL COMMENT '物流单号',
  `create_time` datetime DEFAULT NULL COMMENT 'create_time',
  `ware_id` bigint DEFAULT NULL COMMENT '仓库id',
  `task_comment` varchar(500) DEFAULT NULL COMMENT '工作单备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='库存工作单';

-- ----------------------------
-- Records of wms_ware_order_task
-- ----------------------------
BEGIN;
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (21, NULL, '202305162209088731658474669664325633', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (22, NULL, '202305162216547301658476623606009858', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (23, NULL, '202305162216591251658476642035781633', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (24, NULL, '202305162218542211658477124787589121', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (25, NULL, '202305162222565621658478141243592706', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (26, NULL, '202305162228199971658479497832497153', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (27, NULL, '202305162228474251658479612865478658', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (28, NULL, '202305162234079961658480957441957890', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (29, NULL, '202305182256503071659211447123791873', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (30, NULL, '202305182257026811659211499015720962', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (31, NULL, '202305182300360051659212393765642241', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (32, NULL, '202305182304198911659213332815761409', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (33, NULL, '202305182308291761659214378388647937', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (34, NULL, '202305182308376071659214413750824961', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (35, NULL, '202305182310406591659214929868320769', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (36, NULL, '202305182314512001659215980717633538', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (37, NULL, '202305182315072111659216047868440578', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (40, NULL, '20230623142457651308', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (41, NULL, '20230623142504567132', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (42, NULL, '20230623153306772343', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (43, NULL, '20230623153306772343', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (44, NULL, '20230623153306772343', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (45, NULL, '20230630225357832779', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (46, NULL, '20230630225357832779', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (47, NULL, '20230630225417523815', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (48, NULL, '20230630225357832779', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (49, NULL, '20230630225838596286', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (50, NULL, '20230630225912272671', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (51, NULL, '20230630225933401705', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (52, NULL, '20230630230153301503', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (53, NULL, '20230630230426347101', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (54, NULL, '20230630230445752947', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (55, NULL, '20230630230514562374', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (56, NULL, '20230630232816243948', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (69, NULL, '20230701174916827816', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (80, NULL, '20230702163517614692', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (82, NULL, '20230702202038059884', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (83, NULL, '20230710223401116813', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (84, NULL, '20230710224120624642', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (85, NULL, '20230710230429247511', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (86, NULL, '20230710230440248431', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (87, NULL, '20230710230452050911', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (88, NULL, '20230710230502786341', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (128, NULL, '20230729231505946095', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (129, NULL, '20230730132334940782', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (130, NULL, '20230730132922332715', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (132, NULL, '20230730133009166885', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (133, NULL, '20230730133247596514', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (134, NULL, '20230801222838580250', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (135, NULL, '20230801224303779797', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_ware_order_task` (`id`, `order_id`, `order_sn`, `consignee`, `consignee_tel`, `delivery_address`, `order_comment`, `payment_way`, `task_status`, `order_body`, `tracking_no`, `create_time`, `ware_id`, `task_comment`) VALUES (136, NULL, '20230801224620420214', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for wms_ware_order_task_detail
-- 创建库存工作单详情表
-- ----------------------------
DROP TABLE IF EXISTS `wms_ware_order_task_detail`;
CREATE TABLE `wms_ware_order_task_detail` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sku_id` bigint DEFAULT NULL COMMENT 'sku_id',
  `sku_name` varchar(255) DEFAULT NULL COMMENT 'sku_name',
  `sku_num` int DEFAULT NULL COMMENT '购买个数',
  `task_id` bigint DEFAULT NULL COMMENT '工作单id',
  `ware_id` bigint DEFAULT NULL COMMENT '仓库id',
  `lock_status` int DEFAULT NULL COMMENT '1-已锁定  2-已解锁  3-扣减',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='库存工作单详情表';

-- ----------------------------
-- Records of wms_ware_order_task_detail
-- ----------------------------
BEGIN;
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (33, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 21, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (34, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 21, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (35, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 22, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (36, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 22, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (37, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 23, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (38, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 23, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (39, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 24, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (40, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 24, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (41, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 25, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (42, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 25, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (43, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 26, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (44, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 26, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (45, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 27, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (46, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 27, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (47, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 28, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (48, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 28, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (49, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 29, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (50, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 29, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (51, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 30, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (52, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 30, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (53, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 31, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (54, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 31, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (55, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 32, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (56, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 32, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (57, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 33, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (58, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 33, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (59, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 34, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (60, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 34, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (61, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 35, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (62, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 35, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (63, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 36, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (64, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 36, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (65, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 37, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (66, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 37, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (71, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 40, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (72, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 40, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (73, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 40, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (74, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 41, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (75, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 41, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (76, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 41, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (77, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 42, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (78, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 42, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (79, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 42, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (80, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 43, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (81, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 43, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (82, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 43, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (83, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 44, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (84, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 44, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (85, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 44, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (86, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 45, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (87, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 45, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (88, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 45, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (89, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 46, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (90, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 46, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (91, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 46, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (92, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 47, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (93, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 47, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (94, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 47, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (95, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 48, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (96, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 48, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (97, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 48, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (98, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 49, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (99, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 49, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (100, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 49, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (101, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 50, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (102, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 50, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (103, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 50, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (104, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 51, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (105, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 51, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (106, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 51, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (107, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 52, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (108, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 52, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (109, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 52, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (110, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 53, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (111, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 53, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (112, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 53, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (113, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 54, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (114, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 54, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (115, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 54, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (116, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 55, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (117, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 55, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (118, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 55, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (119, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 2, 56, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (120, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 56, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (121, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 1, 56, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (122, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 1, 69, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (123, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 80, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (124, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 82, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (125, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 83, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (126, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 84, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (127, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 85, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (128, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 86, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (129, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 87, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (130, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 88, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (167, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 128, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (168, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 129, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (169, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 130, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (170, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 1, 132, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (171, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 133, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (172, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 134, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (173, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 135, 1, 1);
INSERT INTO `wms_ware_order_task_detail` (`id`, `sku_id`, `sku_name`, `sku_num`, `task_id`, `ware_id`, `lock_status`) VALUES (174, 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 1, 136, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for wms_ware_sku
-- 商品库存
-- ----------------------------
DROP TABLE IF EXISTS `wms_ware_sku`;
CREATE TABLE `wms_ware_sku` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sku_id` bigint DEFAULT NULL COMMENT 'sku_id',
  `ware_id` bigint DEFAULT NULL COMMENT '仓库id',
  `stock` int DEFAULT NULL COMMENT '库存数',
  `stock_locked` int DEFAULT '0' COMMENT '锁定库存',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sku_id` (`sku_id`) USING BTREE,
  KEY `ware_id` (`ware_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1675422853703544835 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='商品库存';

-- ----------------------------
-- Records of wms_ware_sku
-- ----------------------------
BEGIN;
INSERT INTO `wms_ware_sku` (`id`, `sku_id`, `ware_id`, `stock`, `stock_locked`) VALUES (1, 1647522988067840001, 1, 1000, 32);
INSERT INTO `wms_ware_sku` (`id`, `sku_id`, `ware_id`, `stock`, `stock_locked`) VALUES (2, 1647519694947803138, 1, 1999, 22);
INSERT INTO `wms_ware_sku` (`id`, `sku_id`, `ware_id`, `stock`, `stock_locked`) VALUES (1670457816249405441, 1647522986192986114, 1, 20, 0);
INSERT INTO `wms_ware_sku` (`id`, `sku_id`, `ware_id`, `stock`, `stock_locked`) VALUES (1672128429380734978, 1647519696118013954, 1, 999, 11);
INSERT INTO `wms_ware_sku` (`id`, `sku_id`, `ware_id`, `stock`, `stock_locked`) VALUES (1675422853703544834, 1647519692183756801, 1, 100, 12);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
